All Questions
17 questions
0votes
3answers
109views
How to avoid data corruption with dual parent/child foreign keys
Imagine the following: Persons table: (Id, FirstName, LastName) PersonEmails table: (Id, PersonId, Address) (to allow a person to have multiple emails) Contacts table: (Id, PersonId, UnsubscribeAll) (...
- 175
0votes
1answer
116views
Syncing and matching local records to external database that behaves like a black hole
Black hole problem I am working on matching and daily syncing of our internal data records to an external database that behaves like a black hole, meaning, we cannot view nor extract any data from it ...
1vote
3answers
204views
How to make a data warehouse of a single full Database?
After learning about the data warehouse concepts whole day, I couldn't found a source that can actually say when you should not do data warehousing. In most tutorials I read, it says that DW is for ...
- 119
0votes
1answer
579views
Bridge/Join Table for a Many to Many Relationship between One Table and Multiple Others
Background I have a relational database an I want to have a table that contains flags. I want multiple tables in my database to have a many to many relationship with the flag table. Options I ...
1vote
0answers
33views
Offsetting high usage in a multi-tenant database environment?
I'm writing a research essay over distributed cloud-based systems, and one of the topics that I'm trying to touch on is potential solutions to high database utilization in a single-database multi-...
- 1,387
7votes
3answers
7kviews
Use of booleans in a database
I'm using Visual Studio 2013, .Net 4.5 and SQL Management Studio 2012. I have a table that tracks offices in my database. On the application side there are a some display rules regarding the layout ...
user164461
5votes
2answers
3kviews
One wide table or multiple themed tables?
I'm trying to design a database for a simple text based game where the player characters have a large number of statistics that I want to track. Currently I have a few groups of related statistics, ...
- 173
1vote
3answers
1kviews
Using auto-increment clustered key and guid primary key together
My boss is the db administrator in a new software project and he came up with that design where every table will have both a auto-increment clustered key and a guid primary key (or possibly composite ...
- 1,657
1vote
1answer
364views
storing map template in database
I am working on an application that displays choropleth maps. These maps are of all different types, some display state by county, country by state/province, or world by country. How should I ...
- 111
-6votes
2answers
7kviews
Best way to keep large amounts of data (no relational database needed)
I would like to know what should be the best way to keep data on a server related to the following points: Chat logs Heavy text content User references like amounts of ids (1,4,14,524,23220,...) I'm ...
8votes
4answers
2kviews
What exactly does it mean that storing “large blobs in the database reduces performance”?
To someone who knows database internals this may be an easy question, but can someone explain in a clear way why storing large blobs (say 400 MB movies) in the database is supposed to decrease ...
- 187
5votes
2answers
129views
Tracking changes to posts
I'm currently in the process of writing a support ticket system... Let's say it's a small forum application, or something like Uservoice. Now I want my users to be able to edit their tickets, but ...
- 278
1vote
4answers
6kviews
Storing application users in SQL: create a new "Users" table or use built-in database user management?
I am specifically interested in SQL Server, but the same question applies in general. When creating a new application, the way I see it, there are two options: Create a table called "Users" and store ...
- 928
4votes
1answer
491views
Database Design - Optimise Relationships
I am about to embark on a redesign of an application, one where querying the database is particularly annoying. I intend to redesign the database as much as possible but the data shape cannot change ...
- 1,799
3votes
2answers
1kviews
Referencing countries via Foreign Key Constraint
To make things simple to explain: I've got two tables: Table1 and Countries. The Countries table contains a nice flag and some information, such as DisplayName, the ISO3166 ALPHA3 code and the phone ...
- 278
